const mysql = require("mysql");

var con = mysql.createConnection({
    host: "192.168.182.144",
    port: 3306,
    user: "root",
    password: "ddd",
    database: "mydatabase",
});

var obj = {};
obj.query = async function (sqlStr, arr) {
    return await new Promise((resolve, reject) => {
        con.query(sqlStr, arr, (err, result) => {
            if (err) {
                reject(err);
            } else {
                resolve(result);
            }
        });
    });
};

module.exports = obj;
